A benchmark for online non-blocking schema transformations

This paper presents a benchmark for measuring the blocking behavior of schema transformations in relational database systems. As a basis for our benchmark, we have developed criteria for the functionality and performance of schema transformation mechanisms based on the characteristics of state of the art approaches. To address limitations of existing approaches, we assert that schema transformations must be composable while satisfying the ACID guarantees like regular database transactions. Additionally, we have identified important classes of basic and complex relational schema transformations that a schema transformation mechanism should be able to perform. Based on these transformations and our criteria, we have developed a benchmark that extends the standard TPC-C benchmark with schema transformations, which can be used to analyze the blocking behavior of schema transformations in database systems. The goal of the benchmark is not only to evaluate existing solutions for non-blocking schema transformations, but also to challenge the database community to find solutions that allow more complex transactional schema transformations

Towards Online and Transactional Relational Schema Transformations

In this paper, we want to draw the attention of the database community to the problem of online schema changes: changing the schema of a database without blocking concurrent transactions. We have identified important classes of relational schema transformations that we want to perform online, and we have identified general requirements for the mechanisms that execute these transformations. Using these requirements, we have developed an experiment based on the standard TPC-C benchmark to assess the behaviour of existing systems. We look at PostgreSQL, which does not support online schema changes; MySQL, which supports basic online schema changes; and pt-online-schema-change, which is a tool for MySQL that uses triggers to implement online schema changes. We found that none of the existing systems fulfill our requirements. In particular, existing non-blocking solutions can not maintain the ACID guarantees when composing schema transformations. This leads to intermediate states being exposed to database programs, which are non-trivial to handle correctly. As a solution direction, we propose lazy schema transformations, which can naturally be composed into complex schema transformations that properly guarantee the ACID properties, and which have minimal impact on concurrent transactions

Molecular Imaging for Efficacy of Pharmacologic Intervention in Myocardial Remodeling

ObjectivesUsing molecular imaging techniques, we examined interstitial alterations during postmyocardial infarction (MI) remodeling and assessed the efficacy of antiangiotensin and antimineralocorticoid intervention, alone and in combination.BackgroundThe antagonists of the renin-angiotensin-aldosterone axis restrict myocardial fibrosis and cardiac remodeling after MI and contribute to improved survival. Radionuclide imaging with technetium-99m–labeled Cy5.5 RGD imaging peptide (CRIP) targets myofibroblasts and indirectly allows monitoring of the extent of collagen deposition post-MI.MethodsCRIP was intravenously administered for gamma imaging after 4 weeks of MI in 63 Swiss-Webster mice and in 6 unmanipulated mice. Of 63 animals, 50 were treated with captopril (C), losartan (L), spironolactone (S) alone, or in combination (CL, SC, SL, and SCL), 8 mice received no treatment. Echocardiography was performed for assessment of cardiac remodeling. Hearts were characterized histopathologically for the presence of myofibroblasts and thick and thin collagen fiber deposition.ResultsAcute MI size was similar in all groups. The quantitative CRIP percent injected dose per gram uptake was greatest in the infarct area of untreated control mice (2.30 ± 0.14%) and decreased significantly in animals treated with 1 agent (C, L, or S; 1.71 ± 0.35%; p = 0.0002). The addition of 2 (CL, SC, or SL 1.31 ± 0.40%; p < 0.0001) or 3 agents (SCL; 1.16 ± 0.26%; p < 0.0001) demonstrated further reduction in tracer uptake. The decrease in echocardiographic left ventricular function, strain and rotation parameters, as well as histologically verified deposition of thin collagen fibers, was significantly reduced in treatment groups and correlated with CRIP uptake.ConclusionsRadiolabeled CRIP allows for the evaluation of the efficacy of neurohumoral antagonists after MI and reconfirms superiority of combination therapy. If proven clinically, molecular imaging of the myocardial healing process may help plan an optimal treatment for patients susceptible to heart failure

Elevated risk of infection with SARS-CoV-2 Beta, Gamma, and Delta variants compared with Alpha variant in vaccinated individuals

The extent to which severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2) variants of concern (VOCs) break through infection- or vaccine-induced immunity is not well understood. We analyzed 28,578 sequenced SARS-CoV-2 samples from individuals with known immune status obtained through national community testing in the Netherlands from March to August 2021. We found evidence of an increased risk of infection by the Beta (B.1.351), Gamma (P.1), or Delta (B.1.617.2) variants compared with the Alpha (B.1.1.7) variant after vaccination. No clear differences were found between vaccines. However, the effect was larger in the first 14 to 59 days after complete vaccination compared with ≥60 days. In contrast to vaccine-induced immunity, there was no increased risk for reinfection with Beta, Gamma, or Delta variants relative to the Alpha variant in individuals with infection-induced immunity.</p

Analysis of the blocking behaviour of schema transformations in relational database systems

In earlier work we have extended the TPC-C benchmark with basic and complex schema transformations. This paper uses this benchmark to investigate the blocking behaviour of online schema transformations in PostgreSQL, MySQL and Oracle 11g. First we discuss experiments using the data definition language of the DBMSs, which show that all complex operations are blocking, while we have mixed results for basic transformations. Second, we look at a technique for online schema transformations by Ronström, based on triggers. Our experiments show that pt-online-schema-change for MySQL and DBMS_REDEFINITION for Oracle can perform basic transformations without blocking, however, support for complex transformations is missing. To conclude, we provide a solution outline for complex non-blocking transformations

A Benchmark for Online Non-Blocking Schema Transformations

This paper presents a benchmark for measuring the blocking behavior of schema transformations in relational database systems. As a basis for our benchmark, we have developed criteria for the functionality and performance of schema transformation mechanisms based on the characteristics of state of the art approaches. To address limitations of existing approaches, we assert that schema transformations must be composable while satisfying the ACID guarantees like regular database transactions. Additionally, we have identified important classes of basic and complex relational schema transformations that a schema transformation mechanism should be able to perform. Based on these transformations and our criteria, we have developed a benchmark that extends the standard TPC-C benchmark with schema transformations, which can be used to analyze the blocking behavior of schema transformations in database systems. The goal of the benchmark is not only to evaluate existing solutions for non-blocking schema transformations, but also to challenge the database community to find solutions that allow more complex transactional schema transformations

Myocardial remodeling after infarction: the role of myofibroblasts

Myofibroblasts have characteristics of fibroblasts and smooth muscle cells: they produce extracellular matrix and are able to contract. In so doing, they can contribute to tissue replacement and interstitial fibrosis following cardiac injury. The scar formed after myocardial injury is no longer considered to be passive tissue; it is an active playground where myofibroblasts play a role in collagen turnover and scar contraction. Maintaining the extracellular matrix in the scar is essential and can prevent dilatation of the infarct area leading to heart failure. On the other hand, extracellular matrix deposition at sites remote from the infarct area can lead to cardiac stiffness, an inevitable process of myocardial remodeling that occurs in the aftermath of myocardial infarction and constitutes the basis of the development of heart failure. Defining molecular targets on myofibroblasts in conjunction with establishing the feasibility of molecular imaging of these cells might facilitate the early detection and treatment of patients who are at risk of developing heart failure after myocardial infarction

Molecular imaging of interstitial alterations in remodeling myocardium after myocardial infarction

The purpose of this study was to evaluate interstitial alterations in myocardial remodeling using a radiolabeled Cy5.5-RGD imaging peptide (CRIP) that targets myofibroblasts. Collagen deposition and interstitial fibrosis contribute to cardiac remodeling and heart failure after myocardial infarction (MI). Evaluation of myofibroblastic proliferation should provide indirect evidence of the extent of fibrosis. Of 46 Swiss-Webster mice, MI was induced in 41 by coronary artery occlusion, and 5 were unmanipulated. Of the 41 mice, 6, 6, and 5 received intravenous technetium-99m labeled CRIP for micro-single-photon emission computed tomography imaging 2, 4, and 12 weeks after MI, respectively; 8 received captopril or captopril with losartan up to 4 weeks after MI. Scrambled CRIP was used 4 weeks after MI in 6 mice; the remaining 10 of 46 mice received unradiolabeled CRIP for histologic characterization. Maximum CRIP uptake was observed in the infarct area; quantitative uptake (percent injected dose/g) was highest at 2 weeks (2.75 +/- 0.46%), followed by 4 (2.26 +/- 0.09%) and 12 (1.74 +/- 0.24%) weeks compared with that in unmanipulated mice (0.59 +/- 0.19%). Uptake was higher at 12 weeks in the remote areas. CRIP uptake was histologically traced to myofibroblasts. Captopril alone (1.78 +/- 0.31%) and with losartan (1.13 +/- 0.28%) significantly reduced tracer uptake; scrambled CRIP uptake in infarct area (0.74 +/- 0.17%) was similar to CRIP uptake in normal myocardium. Radiolabeled CRIP allows for noninvasive visualization of interstitial alterations during cardiac remodeling, and is responsive to antiangiotensin treatment. If proven clinically feasible, such a strategy would help identify post-MI patients likely to develop heart failur

Genetics, Clinical Features, and Long-Term Outcome of Noncompaction Cardiomyopathy

Background: The clinical outcomes of noncompaction cardiomyopathy (NCCM) range from asymptomatic to heart failure, arrhythmias, and sudden cardiac death. Genetics play an important role in NCCM. Objectives: This study investigated the correlations among genetics, clinical features, and outcomes in adults and children diagnosed with NCCM. Methods: A retrospective multicenter study from 4 cardiogenetic centers in the Netherlands classified 327 unrelated NCCM patients into 3 categories: 1) genetic, with a mutation in 32% (81 adults; 23 children) of patients; 2) probably genetic, familial cardiomyopathy without a mutation in 16% (45 adults; 8 children) of patients; or 3) sporadic, no family history, without mutation in 52% (149 adults; 21 children) of patients. Clinical features and major adverse cardiac events (MACE) during follow-up were compared across the children and adults. Results: MYH7, MYBPC3, and TTN mutations were the most common mutations (71%) found in genetic NCCM. The risk of having reduced left ventricular (LV) systolic dysfunction was higher for genetic patients compared with the probably genetic and sporadic cases (p = 0.024), with the highest risk in patients with multiple mutations and TTN mutations. Mutations were more frequent in children (p = 0.04) and were associated with MACE (p = 0.025). Adults were more likely to have sporadic NCCM. High risk for cardiac events in children and adults was related to LV systolic dysfunction in mutation carriers, but not in sporadic cases. Patients with MYH7 mutations had low risk for MACE (p = 0.03). Conclusions: NCCM is a heterogeneous condition, and genetic stratification has a role in clinical care. Distinguishing genetic from nongenetic NCCM complements prediction of outcome and may lead to management and follow-up tailored to genetic status

Genetics, Clinical Features, and Long-Term Outcome of Noncompaction Cardiomyopathy

The clinical outcomes of noncompaction cardiomyopathy (NCCM) range from asymptomatic to heart failure, arrhythmias, and sudden cardiac death. Genetics play an important role in NCCM. This study investigated the correlations among genetics, clinical features, and outcomes in adults and children diagnosed with NCCM. A retrospective multicenter study from 4 cardiogenetic centers in the Netherlands classified 327 unrelated NCCM patients into 3 categories: 1) genetic, with a mutation in 32% (81 adults; 23 children) of patients; 2) probably genetic, familial cardiomyopathy without a mutation in 16% (45 adults; 8 children) of patients; or 3) sporadic, no family history, without mutation in 52% (149 adults; 21 children) of patients. Clinical features and major adverse cardiac events (MACE) during follow-up were compared across the children and adults. MYH7, MYBPC3, and TTN mutations were the most common mutations (71%) found in genetic NCCM. The risk of having reduced left ventricular (LV) systolic dysfunction was higher for genetic patients compared with the probably genetic and sporadic cases (p = 0.024), with the highest risk in patients with multiple mutations and TTN mutations. Mutations were more frequent in children (p = 0.04) and were associated with MACE (p = 0.025). Adults were more likely to have sporadic NCCM. High risk for cardiac events in children and adults was related to LV systolic dysfunction in mutation carriers, but not in sporadic cases. Patients with MYH7 mutations had low risk for MACE (p = 0.03). NCCM is a heterogeneous condition, and genetic stratification has a role in clinical care. Distinguishing genetic from nongenetic NCCM complements prediction of outcome and may lead to management and follow-up tailored to genetic statu